Mysql Query statement SQLcodeSELECT * fromde_archiveswherede_archives.titlelike '% Li Ming %' ordede _ archives. titleLIKE '% Huang Fei %' limit0, more than 10 statements are output in the query: Li Ming, yangrui, Li tomorrow, Huang query statements about mysql
SQL code
SELECT * FROM dede_archives where dede_archives.title LIKE '% Li Ming %' or dede_archives.title LIKE '% Huang Fei %' limit 0, 10
The preceding statements are output in the query: Li Ming, yangrui, Li tomorrow, Huang Fei, and Huang Feilong.
I only want to make a perfect match and only output: Li Ming and Huang Fei. What should I do?
------ Solution --------------------
Then, the lz uses the exact query
SELECT * FROM dede_archives where dede_archives.title = 'lilim' or dede_archives.title = 'huangfe' limit
------ Solution --------------------
Discussion
Then, the lz uses the exact query
SELECT * FROM dede_archives where dede_archives.title = 'lilim' or dede_archives.title = 'huangfe' limit