→ MySQL− Codes (wildcards, Formatting) → Start Learning / Download MP3 Flashcards

start learning

Question		Answer
Represents zero or more characters start learning		% bl% finds bl, black, blue, and blob
Represents a single character start learning		_ h_t finds hot, hat, and hit
Represents any single character within the brackets start learning		[] h[oa]t finds hot and hat, but not hit
Represents any character not in the brackets start learning		^ h[^oa]t finds hit, but not hot and hat
Represents a range of characters start learning		- c[a-b]t finds cat and cbt
Abbreviated weekday name (Sun to Sat) start learning		%a
Abbreviated month name (Jan to Dec) start learning		%b
Month number (0 to 12) start learning		%c
Day of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, ...) start learning		%D
Day of the month as a numeric value (01 to 31) start learning		%d
Day of the month as a numeric value (0 to 31) start learning		%e
Microseconds (000000 to 999999) start learning		%f
Hour (00 to 23) start learning		%H
Hour (00 to 12) start learning		%h
Hour (00 to 12) start learning		%I
Minutes (00 to 59) start learning		%i
Day of the year (001 to 366) start learning		%j
Hour (0 to 23) start learning		%k
Hour (1 to 12) start learning		%l
Month name in full (January to December) start learning		%M
Month name as a numeric value (00 to 12) start learning		%m
AM or PM start learning		%p
Time in 12 hour AM or PM format (hh: mm: ss AM/PM) start learning		%r
Seconds (00 to 59) start learning		%S
Seconds (00 to 59) start learning		%s
Time in 24 hour format (hh: mm: ss) start learning		%T
Week where Sunday is the first day of the week (00 to 53) start learning		%U
Week where Monday is the first day of the week (00 to 53) start learning		%u
Week where Sunday is the first day of the week (01 to 53). Used with %X start learning		%V
Week where Monday is the first day of the week (01 to 53). Used with %x start learning		%v
Weekday name in full (Sunday to Saturday) start learning		%W
Day of the week where Sunday=0 and Saturday=6 start learning		%w
Year for the week where Sunday is the first day of the week. Used with %V start learning		%X
Year for the week where Monday is the first day of the week. Used with %v start learning		%x
Year as a numeric, 4-digit value start learning		%Y
Year as a numeric, 2-digit value start learning		%y

MySQL− codes (wildcards, formatting)

You must sign in to write a comment

More