How do i perform a search in mysql with a substring, instead of full string?

Question

How do i perform a search in mysql with a substring, instead of full string ?

i would like to return information from a search term e.g.. 'Wat' will return Waterloo and any other words with Wat in them ..

yes i did.. just realize i am responding to this really late! :/ @FilipeSilva — Karim, Nov 07 '14 at 19:40

score 2 · Answer 1 · answered Sep 27 '13 at 21:04

2

You can do it with a like:

SELECT * FROM YOUR_TABLE
WHERE YOURCOLUMN LIKE '%Wat%';

If you are only looking for something starting with Wat you can drop the first %

answered Sep 27 '13 at 21:04

Filipe Silva

score 1 · Accepted Answer · answered Sep 27 '13 at 21:07

1

You can use like '%Wat%', but if you want more sophisticated conditions, you may consider using rlike which leverages regular expressions

answered Sep 27 '13 at 21:07

senseiwu

@KarimKawambwa you are welcome. Be careful though that searching using `like` does have an impact on performance. See http://stackoverflow.com/questions/2481528/mysql-like-performance-boost – senseiwu Oct 13 '13 at 18:30

2 Answers2