MySQL 5.0 : MySQL's First Major 5.0 Release

learn more… | top users | synonyms

0
votes
0answers
13 views

I have a row which has 10 columns in which many column have 'a' as a character in it

How to write a query for searching the pattern if there is 'any' single character in the row or rows in the table.
0
votes
0answers
47 views

CREATE VIEW joining two tables, only displaying rows from the first table with the most recent date in the second table

I have multiple tables. My main table has a composite key consisting of a phone number and an order number. I want to create a VIEW where only the subscriptions with the most recent order date are ...