I have
SELECT * FROM hnurl WHERE title LIKE('%text1%')
How do I extend this to also add in things LIKE('%text2%')? within the same query results?
-
2It depends on your need. It can be an AND, it can be an OR.Aurelio De Rosa– Aurelio De Rosa2011-11-13 20:53:14 +00:00Commented Nov 13, 2011 at 20:53
Add a comment
|
4 Answers
Have you tried:
SELECT * FROM hnurl WHERE title LIKE '%text1%' OR title LIKE '%text2%';
1 Comment
Mark Byers
@David19801: In MySQL
|| also works. See the documentation: dev.mysql.com/doc/refman/5.0/en/… Your problem must be something else.Use OR if you want rows where either or both strings are found:
SELECT * FROM hnurl
WHERE title LIKE '%text1%'
OR title LIKE '%text2%'
Use AND if you want rows where both strings are found:
SELECT * FROM hnurl
WHERE title LIKE '%text1%'
AND title LIKE '%text2%'
Sidenote: You may also wish to consider using a full-text search or an external text search engine to improve the performance of your queries.
2 Comments
David19801
to use an external engine, would I have to put my entire database with them? What would hte benefit of full text search be over what I am doing here?
Mark Byers
@David19801: The benefit? It's faster. Much, much faster.
You could add
... OR title LIKE '%text2%'
Comments
It is also possible with MySQL REGEXP, see the most simplified examples at http://dev.mysql.com/doc/refman/5.1/en/regexp.html, something like:
SELECT * FROM hnurl
WHERE title REGEXP 'text(1|2)'
Variations possible.
