select string within string???

[nikko50]

Hi guys🙂
How can I use a
select statement to search for a string such as "widget" in a field. Now... the string can be at the beginning or end or middle of a string like.....

widgetforme
formewidget
forwidgetme

How can I search for this??

[bradgrafelman]

Using the % character in conjunction with the LIKE syntax (MySQL manual reference: Pattern Matching) should accomplish what you seek:

SELECT `fieldName` FROM `myTable` WHERE `fieldName` LIKE '%widget%'