MYSQL Programming, For Beginners, Quick Start Guide. by Yao Ray

Author:Yao, Ray [Yao, Ray]
Language: eng
Format: epub
Publisher: Step by Step Tutorial eBook & Book
Published: 2020-08-05T16:00:00+00:00

# 4 . Get the field’s length .

select writer, length (writer) from books where id = 3;

# 5 . Get the writer the sound like “R Y”

select soundex (writer), writer from books

where soundex (writer) = soundex ("R Y");

Explanation:

“select substring (title, 2, 3) from books;” extracts three characters from the title field at index 2 .

“select upper (title), lower (title) from books;” converts the field to uppercase and lowercase .

“select writer, length (writer) from books where id = 3;” gets the field’s length .

“select soundex (writer), writer from books

where soundex (writer) = soundex ("R Y");” gets the writer the sound like “R Y”

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.