Sharon Christine has Published 461 Answers

How to set a string with hyphen and numbers in MySQL varchar?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:53:58

To set a string with hyphen and numbers, you need to use single quotes. For example, 'Customer-1234-899', 'Customer-9383-901', etc.Let us first create a table −mysql> create table DemoTable -> ( -> CustomerId varchar(100) -> ); Query OK, 0 rows affected (0.70 sec)Insert some records in the table using insert command ... Read More

Extract the middle part of column values in MySQL surrounded with hyphens and display in a new column?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:52:20

Use the SUBSTR() method to extract the middle part of column values surrounded with hyphens, for example, “11-84848-11”.Let us first create a table −mysql> create table DemoTable -> ( -> Number varchar(100), -> Number1 varchar(100) -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using ... Read More

Discard last 3 characters of a field in MySQL

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:43:52

Let us first create a table −mysql> create table DemoTable    -> (    -> StudentId varchar(100)    -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('STU-090'); Query OK, 1 row affected (0.16 sec) mysql> insert ... Read More

Comparing two columns in a single MySQL query to get one row?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:42:26

For this, you can use ORDER BY clause. Let us first create a table −mysql> create table DemoTable -> ( -> Num1 int, -> Num2 int -> ); Query OK, 0 rows affected (0.61 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(60, 249); Query ... Read More

Searching for an integer value in a varchar field in MySQL?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:37:17

To search for an integer value in a varchar filed, you can use CASE statement.Let us first create a table. Consider, we have a list of email-ids −mysql> create table DemoTable -> ( -> Title varchar(100) -> ); Query OK, 0 rows affected (0.61 sec)Insert some records in the table ... Read More

MySQL query to create table dynamically?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:36:25

For this, you can use stored procedure. Let us create a table dynamically with two columns i.e. StudentId as int, whereas StudentName as varchar −mysql> DELIMITER $$ mysql> CREATE PROCEDURE creatingDynamicTableDemo(yourTableName VARCHAR(200))    -> BEGIN    ->    SET @name = yourTableName;    ->    SET @st = CONCAT('   ... Read More

MySQL query to fetch record by year

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:34:59

To fetch record by year, use the YEAR() method in MySQL −select *from yourTableName where year(yourColumnName)=yourYearValue;Let us first create a table −mysql> create table DemoTable -> ( -> CustomerName varchar(100), -> ShippingDate datetime -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command ... Read More

MySQL query with two boolean conditions to extract date based on hour?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:24:50

Let us first create a table −mysql> create table DemoTable    -> (    -> AdmissionDate datetime    -> ); Query OK, 0 rows affected (0.75 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('2019-01-10 10:45:10'); Query OK, 1 row affected (0.30 sec) mysql> ... Read More

Remove all except the first character of a string in MySQL?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:24:00

For this, use the LEFT() method, which returns a specified number of characters from the left of the string.Let us first create a table −mysql> create table DemoTable    -> (    -> FirstName varchar(100)    -> ); Query OK, 0 rows affected (0.96 sec)Insert some records in the table ... Read More

How do I select 5 random rows from the 20 most recent rows in MySQL?

Sharon Christine

Sharon Christine

Updated on 30-Jun-2020 13:22:49

For random, use RAND() method. And for limit on rows, use the LIMIT() method.Let us first create a table −mysql> create table DemoTable    -> (    -> ShippingDate datetime    -> ); Query OK, 0 rows affected (0.51 sec)Insert some records in the table using insert command −mysql> insert ... Read More

Previous 1 ... 4 5 6 7 8 9 10 ... 47 Next
Advertisements