question

Gopalakrishnan avatar image
Gopalakrishnan asked

How to return all rows having matched word on single column...?

I have a table named "Clients" with id, name, address, phone etc... my question is: If i want bring up a results with every client that includes the key words “Smith Street” in their address field. How to do this.....?
sqlmysql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
How about: select * from Clients where [address] like '%Smith Street%';
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

emil87b avatar image emil87b commented ·
homework done :)
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.