如何从PHP中的字符串中取一些特定的单词？

Question

I have a table in mysql that contain two columns or fields, one column is for an id_column and others for description of string type. I would like to insert an specific string to the column description.

For example:

insert into table_name (id, description) values ('1','we go to school')

And then in my php file, I would like to fetch the specific word "school" from the column description.

How can I do this?

Answer 1

You can use like with wildchar .

   select * from your_table 
   where description like '%school%';

in php for find if a string contain a word you can use

$my_string = 'we go to school';

if (strpos($my_strong, 'school') !== false) {
   echo 'string found';
}