πŸ“Š MySQL
Q. What is abc in the following MySQL statement?
SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');
  • (A) column name
  • (B) table name
  • (C) search string
  • (D) database name
πŸ’¬ Discuss
βœ… Correct Answer: (A) column name

Explanation: Column name: In the MATCH clause, abc represents the name of the column against which the full-text search is performed. In this case, the search is conducted in the column named abc within the my_table table.

Explanation by: Kiran Rapria
Column name: In the MATCH clause, abc represents the name of the column against which the full-text search is performed. In this case, the search is conducted in the column named abc within the my_table table.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
69
Total Visits
πŸ“½οΈ
12 mo ago
Published
πŸŽ–οΈ
Kiran Rapria
Publisher
πŸ“ˆ
94%
Success Rate