/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 vote384 views1 answer
SQL-Arten
SQL
0 vote372 views1 answer
Do you know sql
SQL
0 vote397 views1 answer
Get primary key of table
SQL
2 votes414 views2 answers
Set value to null sql
SQL
0 vote326 views1 answer
Get number of table colums in sql query
SQL
0 vote358 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote352 views1 answer
Get who is hired in specific month in sql
SQL
0 vote350 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote368 views1 answer
Change magento database url usimg musql
SQL
2 votes340 views1 answer
Insert from table tsql
SQL

Share