/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

1 vote145 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote120 views1 answer
If null don't update
SQL
0 vote148 views1 answer
Mysqldump: error:
SQL
1 vote121 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote124 views1 answer
Sql change default collation to utf8
SQL
0 vote147 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote142 views1 answer
Mariadb change column type
SQL
1 vote131 views3 answers
How to pass password to mysql command line
SQL
0 vote123 views1 answer
Mysql export search results
SQL
1 vote145 views1 answer
Mysql view current queries
SQL

Share