/SQL/Mysql keyword search

Mysql keyword search

Sql searching via key word

SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')

0

Source: stackoverflow.com

Sql searching via key word

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)

0

Source: stackoverflow.com

Mysql keyword search

SELECT title, description
FROM film
WHERE
(
    title LIKE '%Drama%'
    OR description LIKE '%Drama%'
);

0

Source: stackoverflow.com

Similar codes

0 vote223 views2 answers
While mysql
SQL
0 vote260 views3 answers
Select top 10 rows in sql
SQL
0 vote214 views2 answers
Plpgsql
SQL
3 votes202 views1 answer
Pl sql escape &
SQL
3 votes191 views1 answer
Make a field auto_increment mysql
SQL
2 votes191 views2 answers
Mamp connect mysql terminal
SQL
0 vote188 views1 answer
Inserted row count tsql
SQL
1 vote185 views1 answer
Show table columns
SQL
1 vote193 views1 answer
Sql group by error
SQL
6 votes219 views2 answers
Clear a table in mysql
SQL

Share