Home  >  Databases  >  MySQL Test

You are working with the table in this diagram. You want to use full-text search to find the customers who live on a street or a drive. What is the command to do that?Table name: customers| ID | lastname | firstname | phone | address | city | state | zip || ---- | -------- | --------- | ------------ | ------------------- | ----------- | ----- | ----- || A001 | Smith | Bob | 212-555-1212 | 1001 1st Street | New York | NY | 10001 || A002 | Chang | John | 213-555-5678 | 888 Rodeo Drive | Los Angeles | CA | 90210 || A003 | Smith | Mary | 999-999-9999 | 123 Main Street | Anytown | VA | 12345 || A004 | Johnson | Jack | 312-312-3120 | 1111 Chicago Avenue | Chicago | IL | 60606 || A005 | Lopez | Linda | 737-777-3333 | 123 Main Street | Austin | TX | 73344 |

🎲 Try a Random Question  |  Total Questions in Quiz: 98  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
MySQL Test — practice the complete quiz, review flashcards, or try a random question.
🧠 Flashcards (fast review) 🧪 Practice Quiz ⚔️ Challenge a Friend 🥊 📊 View Stats

MySQL MCQs For LinkedIn Skill Assessments.


You are working with the table in this diagram. You want to use full-text search to find the customers who live on a street or a drive. What is the command to do that?<br>Table name: customers<br>| ID | lastname | firstname | phone | address | city | state | zip |<br>| ---- | -------- | --------- | ------------ | ------------------- | ----------- | ----- | ----- |<br>| A001 | Smith | Bob | 212-555-1212 | 1001 1st Street | New York | NY | 10001 |<br>| A002 | Chang | John | 213-555-5678 | 888 Rodeo Drive | Los Angeles | CA | 90210 |<br>| A003 | Smith | Mary | 999-999-9999 | 123 Main Street | Anytown | VA | 12345 |<br>| A004 | Johnson | Jack | 312-312-3120 | 1111 Chicago Avenue | Chicago | IL | 60606 |<br>| A005 | Lopez | Linda | 737-777-3333 | 123 Main Street | Austin | TX | 73344 |






 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.