vothanh4231 Posts - Answer Overflow

vothanh4231

•Created by vothanh4231 on 10/19/2023 in #❓┊help

I want to search for an exact phrase from the "customers" table

Hi all, I want to search for an exact phrase, for example "John Doe" from the "customers" table However, the default query is

select * from `customers` where ((`name` like '%John%')) and ((`name` like '%Doe%'))

select * from `customers` where ((`name` like '%John%')) and ((`name` like '%Doe%'))

I want the query to have: where name like '%John Doe%' The problem is in this method extractTableSearchWords()

9 replies