GK SCIENTIST

General Knowledge One Stop Source
Menu
  • Home
  • Social Science
    • History
    • Political Science
    • Geography
  • Science
    • Physics
    • Chemistry
    • Biology
  • Chemistry Notes
  • Mathematics
  • Computer
  • Tutorial MySQL
  • Tutorial Python
  • Java Tutorial
  • English Grammar
  • English Essay
  • Indian Anthropology
  • Philosophy
  • Solved Paper
  • UPSC
  • Current Content
    • Current Affairs
    • RSTV News
    • Yojana and Kurukshetra Gist
  • Donate
  • Contact Us

If you are interested in advertising to our audience, submit the advertising enquiry form.

Advertising Enquiry
Computer

MySQL LIKE Operator

Gk Scientist November 14, 2022 No Comments
Tweet WhatsApp Telegram

MySQL LIKE Operator:

  • MySQL LIKE Operator checks whether a specific character string matches a specified pattern.
  • MySQL LIKE Operator uses WILDCARDS (i.e. %, _, [ ], ^) to match the pattern. This is very useful to check whether a particular character or string is present in the records.
  • The percent sign (%) represents zero, one, or multiple characters.
  • The underscore sign (_) represents one, single character.

Example of MySQL LIKE Operator:

Example of LIKE Operator ‘s%’: Finds any values that start with “s”.

Example of MySQL LIKE Operator s - MySQL LIKE Operator

Example of LIKE Operator ‘%s’: Finds any values that end with “s”.

Example of MySQL LIKE Operator s 2 - MySQL LIKE Operator

Example of LIKE Operator ‘%s%’: Finds any values that have “s” in any position.

Example of MySQL LIKE Operator s 1 - MySQL LIKE Operator

Example of LIKE Operator ‘_a%’: Finds any values that have “a” in the second position.

MySQL Example of LIKE Operator  a - MySQL LIKE Operator

Example of LIKE Operator ‘c_%‘: Finds any values that start with “c” and are at least 2 characters in length.

MySQL Example of LIKE Operator c  - MySQL LIKE Operator

Example of LIKE Operator ‘s%n’: Finds any values that start with “s” and end with “n”.

MySQL Example of LIKE Operator sn - MySQL LIKE Operator

Operating System (OS)
Applications of Computer
Computer Input Devices
Computer Output Devices
Multimedia and Its Application
MySQL– Wikipedia
Prev Article
Next Article

Related Articles

World Wide Web (WWW)
World Wide Web: From the late 1960s to the early …
Gk Scientist September 16, 2022 Computer

World Wide Web (WWW)

Create Table In MySQL Python
Create Table In MySQL Python: (1) You have to open …
Gk Scientist December 12, 2022 Computer

Create Table In MySQL Python

Java this Keyword
Java this Keyword: We can use the Eclipse IDE for …
Gk Scientist January 8, 2023 Computer

Java this Keyword

Structured Programming- Advantages and Disadvantages
Structured Programming: In structured programming design, programs are broken into …
Gk Scientist August 9, 2022 Computer

Structured Programming- Advantages and Disadvantages

Java Encapsulation
Java Encapsulation: We can use the Eclipse IDE for this …
Gk Scientist January 9, 2023 Computer

Java Encapsulation

Java for-each Loop
Java for-each Loop: We can use the Eclipse IDE for …
Gk Scientist January 6, 2023 Computer

Java for-each Loop

Procedure-Oriented Programming
Procedure-Oriented Programming: Procedure-Oriented Programming is the traditional way of programming, …
Gk Scientist August 14, 2022 Computer

Procedure-Oriented Programming

Python Arithmetic Operators
Python Arithmetic Operators: We can use the PyCharm code editor …
Gk Scientist November 21, 2022 Computer

Python Arithmetic Operators

Leave a Reply Cancel Reply

Search




  • Popular
  • Recent




GK SCIENTIST

General Knowledge One Stop Source

Information

  • About Us
  • Terms and Condition, Disclaimer
  • Contact Us

Android Apps

  • IAS App For English Medium Students
  • IAS Basics App For English Medium Students
  • IAS Hindi App For Hindi Medium Students
DMCA.com Protection Status

Popular Tags

Biology (33) Biology Questions (88) Chemistry (57) Computer (212) Current Affairs (4) Current Content (0) Economy (10) English Essay (172) English Grammar (75) English Literature (10) Geography (83) History (259) Indian Anthropology (11) Indian Polity (14) JKAS Mains Question Papers (17) Mathematics (68) Moral Science (7) NCERT & Other Boards Books (25) Philosophy (114) Physics (89) Political Science (132) RS TV News (33) Science (553) Social Anthropology (7) Social Science (17) Solved Paper (47) UPSC (7) UPSC Mains Question Papers (26)

Downloads

  • NCERT Books
  • Old NCERT Books
  • NIOS Books For IAS, SSC, and State PSC Exam
  • Tamil Nadu Board Books: Important For UPSC, SSC, and State PSC Exam
  • Modern Indian and World History Notes For IAS Exam
  • UPSC Topper 2013 Gaurav Agrawal Notes For IAS Preparation
  • UPSC IAS Prelims General Studies – Previous Year Papers
  • UPSC Mains Question Papers

Copyright © 2023 GK SCIENTIST
Theme by MyThemeShop.com& Hosted On Cloudways
 

Loading Comments...